• Notes 11/09
    • A.1 and A.2 are completed
    • A.3 working on data for income indicators
    • A.3 edit spatial maps after completing income plots

A.1. Student Enrollment Both Count and change

Students of color or low income students are further disadvantaged during the pandemic in terms of enrollment. Particularly lower grade levels

A.1.1 Student Enrollment Count for Kindergarteners 6th and 9th Graders

A.1.2 Student Enrollment Percentagee for Kindergarteners 6th and 9th Graders

A.1.3. Student Enrollment Change for Kindergarteners 6th and 9th Graders

Change from SY 2019-20 to SY 2020-21; NO SY 2018-29 ENROLL COUNTS DATA AT GRADE LEVEL


A.2. Student absence both count and change

Students of color or low income students are further disadvantaged during the pandemic in terms of abs. Particularly lower grade levels Grade K, 3rd, 6th, 8th, 9th, 10th grade.


A.3. Course Taking

A.3.1. Statewide breakdown by groups

A.3.2.1 Geographical differences across districts in all non-passing grade from 2018-19 to 2020-21

students of color (excluding Asian)

For spatial plots: missing data (grey areas) results from

  1. missing and suppression at district level;
  2. some districts have data for only one of the SYs, then the changes are going to be NAs;
  3. some districts in the shapefile do not appear in the ospi data (shows in “match district names with shape file” section)
Reading layer `Washington_School_District_Boundaries' from data source 
  `/Users/alexliu/Documents/GitHub/evidenceforequity/A/enrollment_absence_dataset/Washington_School_District_Boundaries-shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 295 features and 23 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: 576751.6 ymin: 81877.25 xmax: 2551198 ymax: 1355595
Projected CRS: NAD83(HARN) / Washington South (ftUS)

A.3.2.2 The gap in all non-passing in 2020-21 between students of color and white for each district

Reading layer `Washington_School_District_Boundaries' from data source 
  `/Users/alexliu/Documents/GitHub/evidenceforequity/A/enrollment_absence_dataset/Washington_School_District_Boundaries-shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 295 features and 23 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: 576751.6 ymin: 81877.25 xmax: 2551198 ymax: 1355595
Projected CRS: NAD83(HARN) / Washington South (ftUS)

on track:

  • 9th grade on track: did not get a grade of D or F. The % of students that received grades of A,B, C.
  • Regular attendance, meaning that has more than 90% attendance during the year
  • Dual credit (not prestigious): (AP/IB courses is more prestigious); therefore, less useful
  • COVID-19 modified (beginning of the school year to march, 2019-20 school year). The “modified” may indicate that. then OSPI created a fall to march dataset for multiple years of data

Graduation (the class of 2020).

https://www.k12.wa.us/data-reporting/data-displays/graduation-pathways-display Different pathways by income and students of color